ǳлʹԵCMS2006

ʾַwww.cmsdo.com
ٷվwww.52so.net

ָQQ349151746

ĬϹԵ    룺admin

վͷ޸ķ


Ŀ¼adsļ 
ҵtop_ads.jsļ 
ü±򿪺ͿԿ:
--------------------------------------


ûעἸĬֵ趨

register.asp
ûעļʼֵ趨 һ ܶ

rs("bbs_counter")=0           //
rs("counter")=0               //ûϵ Ҫ
rs("integral")=0               //
rs("emoney")=0              //Ǯ
rs("nname")="ѻԱ"              //ͷ
rs("birthday")="1970-7-17"              //
rs("whe")=""              //Ķ
rs("face")="images/face/4.gif"              //Ĭͷ
rs("face_w")=80              //ͷ
rs("face_h")=80              //ͷ߶
rs("qq")=0              //qq
rs("msn")=""              //msn
rs("url")=""              //ҳ
rs("phone")=""              //绰
rs("address")=""              //ַ

վָĳʱʾԵ硻ӭ޸ķ  
վĿ¼ļ
styleļ
mouse_on_title.jsļ
-----------------------
pltsTipLayer.style.left=-1000;
pltsTipLayer.style.display='';
var Msg=pltsPop.replace(/
/g,"<br>");
Msg=Msg.replace(/\0x13/g,"<br>");
var re=/\{(.[^\{]*)\}/ig;
if(!re.test(Msg))pltsTitle="Ե硻 ӭ";
------------------------

Ҳ˵ô˰!


 
ݿ/վCookies޸ķ


޸ļinclude/config.asp

set joekoe_cms=new class_joekoe_cms
'---------------------------------ݿַ------------------------------
joekoe_cms.connstr="DBQ="&server.mappath("ݿ·")&";DRIVER={Microsoft Access Driver (*.mdb)};"
'----------------------------------վCookies----------------------------
joekoe_cms.web_cookies="joekoe_online"
'---------------------------------------------------------------------------------


̳Ӽ漴޸ķ

򿪸Ŀ¼ļstyle,ҵļΪ:data_ads_txt_forumļ,:


ҲԵ̨ϵͳ>>>>ֹ>>ֹ̳

ǵҪ̳JS 



վ//޸ķ

޸ķ£

ִ̨SQL

update configs set counter=43927,max_online=590,start_tim='2054121212ʱ1212'
counter=1ָǰ
max_online=2ָ߷
start_tim='2054121212ʱ1212'

Ȼǵøһݣ


1200ܷĽ 
1200 ---100ܷ⣡

 skin.asp ļҵ
 Ϊݣ
sub time_lock()
   if web_dim(10)="" then exit sub
   dim nh,tt
   nh=int(hour(joekoe_cms.now_time))
   for i=1 to len(web_dim(10))
     if int(mid(web_dim(10),i,1))=1 then tt=i-1
   next
   if nh=tt then call web_error("time_lock")
  end sub 
 

 滻´Ϳˡ
 Ϊݣ
sub time_lock()
   if web_dim(10)=0 then exit sub
   dim nh,tt
   nh=int(hour(joekoe_cms.now_time))
   for i=1 to len(web_dim(10))
     if i=1 then
   if int(mid(web_dim(10),i,1))=0 then
   tt=i
   end if
   else
   if int(mid(web_dim(10),i,1))=1 then tt=i-1
   end if
   if nh=tt then call web_error("time_lock")
   next
 end sub
 


Ȼ󵽺̨ʱ䶼϶Թ,.

ҪҲʱֻҪذļͷĴͿ


ԱȨ޸ 

ЩվСں̨=>=>Ա
޸ĳԱʱûдˣԭĹԱ͵ǲȥˡ
¸ĵĹԱԵ½ȥûСĹ

ûйϵģķ

include/common.asp
web_dim(3)=
ϾӦúðɣûԣӦ!

ĵġԵ硻޸ķ 

̨Ĺģáѡģ༭ģ塪˵Ұɣ





̳ϵġԵ硻޸ķ 

̨Ĺ˵վ˵

CMS SQL󼯺


1û update user_data set username='' where username=''

2߷巢 update configs set max_tim=2004-1-1

ͬʱ update configs set max_online=10

ܷ update configs set counter=1000

ͳʱ update configs set start_tim='200411'

3ɾ3ûе¼ĻԱ delete from user_data where datediff('n',last_tim,now())>3

ɾĳԱһʱе delete from bbs_topic where tim<#ʱ# and tim>#ʱ2# and username=''

ɾĳԱһʱеĻ delete from bbs_data where tim<#ʱ# and tim>#ʱ2# and username=''

ɾΪֵĻԱӦѽ delete from user_data where integral<0
գֻʣһԱsql delete table where id=ID

4޸SQL
ָ
update news set username='xxx',comto='xxxx' where id=1
ȫ
update news set username='xxx',comto='xxxx' where 1=1

newsĳarticle

5ؽҸΪ2
update down set emoney=2
ӰԺȾɲִ
ǼؽҸΪ2,ǼΪ1
update down set emoney=2 where types=5
update down set emoney=1 where types=4
(Դ) 

6ûзĻ֣update user_data set integral=0 where bbs_counter=0

ɾ20ӣdelete from bbs_topic where counter<20

ɾο͵½¼delete from user_login 

7վupdate configs set counter=** 
max_tim 
max_online ʱ

8Ҫ۳ĳһIDΪ A  עû10Ӧִأ
update user_data set emoney=emoney-10 where username='A'

9̨û
update user_data set username='****' where id=*

10ɾ30δ½һδû
delete from user_data where bbs_counter<1 and datediff('d',last_tim,now())>30

11ÿλû10Ԫ
update user_data set emoney=emoney+10

12ɾעûзһû
delete from user_data where bbs_counter<1

ɾ30δ½û
delete from user_data where DateDiff('d',last_tim,now())>30

13100Ԫ
update user_data set emoney=emoney+100 where username='JK'

14ɾָû̳
delete from bbs_data where username='sdk'

delete from bbs_topic where username='sdk' 

15û update user_data set username='' where username=''

16ɾΪֵĻԱӦѽ delete from user_data where integral<0
գֻʣһԱsql delete table where id=ID

17ɾ3ûе¼ĻԱ 
delete from user_data where datediff('n',last_tim,now())>3

18ֶ():
alter table ݱ add column ֶ int
update ݱ set ֶ=ֵ(1,2,3.....)
ֶ:(߼)
alter table ݱ add ֶ bit null
ֶ:(ı)
alter table ݱ add column ֶ text(ֽڶ<250>)

19ɾĳָ
delete from bbs_topic where forum_id=̳id and id=id


